[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '154' >
2 items
| DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SickLeaveHours | StartDate | Status | Title | VacationHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192 | 32.4519 | 1991-06-23 | Information Services | peter1@adventure-works.com | Peter Connelly | 310-555-0133 | 672243793 | Peter | M | 2020-03-20 | Connelly | adventure-works\peter1 | S | I | 154 | 2 | 310-555-0133 | | 54 | 2020-03-20 | Current | Network Administrator | 69 |
| 30 | 32.4519 | 1988-04-21 | Information Services | ashvini0@adventure-works.com | Ashvini Sharma | 656-555-0119 | 749389530 | Ashvini | M | 2019-12-30 | Sharma | adventure-works\ashvini0 | S | R | 154 | 2 | 656-555-0119 | | 55 | 2019-12-30 | Current | Network Administrator | 70 |
Generated 2025-07-25 20:45:27.956 UTC